<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "https://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<meta name="generator" content="Doxygen 1.8.17"/>
<meta name="viewport" content="width=device-width, initial-scale=1"/>
<title>Aestate: aestate.work.sql.ExecuteSql.Db_opera Class Reference</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="dynsections.js"></script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/searchdata.js"></script>
<script type="text/javascript" src="search/search.js"></script>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  <td id="projectalign" style="padding-left: 0.5em;">
   <div id="projectname">Aestate
   &#160;<span id="projectnumber">1.0.5</span>
   </div>
  </td>
 </tr>
 </tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.8.17 -->
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
var searchBox = new SearchBox("searchBox", "search",false,'Search');
/* @license-end */
</script>
<script type="text/javascript" src="menudata.js"></script>
<script type="text/javascript" src="menu.js"></script>
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
$(function() {
  initMenu('',true,false,'search.php','Search');
  $(document).ready(function() { init_search(); });
});
/* @license-end */</script>
<div id="main-nav"></div>
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
</div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>

<div id="nav-path" class="navpath">
  <ul>
<li class="navelem"><a class="el" href="namespaceaestate.html">aestate</a></li><li class="navelem"><a class="el" href="namespaceaestate_1_1work.html">work</a></li><li class="navelem"><a class="el" href="namespaceaestate_1_1work_1_1sql.html">sql</a></li><li class="navelem"><a class="el" href="namespaceaestate_1_1work_1_1sql_1_1_execute_sql.html">ExecuteSql</a></li><li class="navelem"><a class="el" href="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera.html">Db_opera</a></li>  </ul>
</div>
</div><!-- top -->
<div class="header">
  <div class="summary">
<a href="#pub-methods">Public Member Functions</a> &#124;
<a href="#pub-attribs">Public Attributes</a> &#124;
<a href="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera-members.html">List of all members</a>  </div>
  <div class="headertitle">
<div class="title">aestate.work.sql.ExecuteSql.Db_opera Class Reference</div>  </div>
</div><!--header-->
<div class="contents">
<div class="dynheader">
Inheritance diagram for aestate.work.sql.ExecuteSql.Db_opera:</div>
<div class="dyncontent">
<div class="center"><img src="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera__inherit__graph.png" border="0" usemap="#aestate_8work_8sql_8_execute_sql_8_db__opera_inherit__map" alt="Inheritance graph"/></div>
<map name="aestate_8work_8sql_8_execute_sql_8_db__opera_inherit__map" id="aestate_8work_8sql_8_execute_sql_8_db__opera_inherit__map">
<area shape="rect" title=" " alt="" coords="18,483,203,648"/>
<area shape="rect" href="classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b.html" title=" " alt="" coords="5,5,216,435"/>
</map>
</div>
<div class="dynheader">
Collaboration diagram for aestate.work.sql.ExecuteSql.Db_opera:</div>
<div class="dyncontent">
<div class="center"><img src="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera__coll__graph.png" border="0" usemap="#aestate_8work_8sql_8_execute_sql_8_db__opera_coll__map" alt="Collaboration graph"/></div>
<map name="aestate_8work_8sql_8_execute_sql_8_db__opera_coll__map" id="aestate_8work_8sql_8_execute_sql_8_db__opera_coll__map">
<area shape="rect" title=" " alt="" coords="18,483,203,648"/>
<area shape="rect" href="classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b.html" title=" " alt="" coords="5,5,216,435"/>
</map>
</div>
<table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pub-methods"></a>
Public Member Functions</h2></td></tr>
<tr class="memitem:aba9a630a95683f961029692b32a22a97"><td class="memItemLeft" align="right" valign="top">def&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera.html#aba9a630a95683f961029692b32a22a97">__init__</a> (self, *args, **kwargs)</td></tr>
<tr class="separator:aba9a630a95683f961029692b32a22a97"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:af621539312f85b1fb61330704f011053"><td class="memItemLeft" align="right" valign="top">def&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera.html#af621539312f85b1fb61330704f011053">get_conn</a> (self)</td></tr>
<tr class="separator:af621539312f85b1fb61330704f011053"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:afc77558cf0747f2325b05305c6ca01ad"><td class="memItemLeft" align="right" valign="top">def&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera.html#afc77558cf0747f2325b05305c6ca01ad">select</a> (self, **kwargs)</td></tr>
<tr class="separator:afc77558cf0747f2325b05305c6ca01ad"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a9287232ddbcabdb67c39f934aecc5774"><td class="memItemLeft" align="right" valign="top">def&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera.html#a9287232ddbcabdb67c39f934aecc5774">insert</a> (self, many=False, **kwargs)</td></tr>
<tr class="separator:a9287232ddbcabdb67c39f934aecc5774"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:af488911adbdabd74a5f54c6c6b4f17d9"><td class="memItemLeft" align="right" valign="top">def&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera.html#af488911adbdabd74a5f54c6c6b4f17d9">update</a> (self, **kwargs)</td></tr>
<tr class="separator:af488911adbdabd74a5f54c6c6b4f17d9"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a1366af70de61ad202ddd95d0c020ce05"><td class="memItemLeft" align="right" valign="top">def&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera.html#a1366af70de61ad202ddd95d0c020ce05">delete</a> (self, **kwargs)</td></tr>
<tr class="separator:a1366af70de61ad202ddd95d0c020ce05"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="inherit_header pub_methods_classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b"><td colspan="2" onclick="javascript:toggleInherit('pub_methods_classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b')"><img src="closed.png" alt="-"/>&#160;Public Member Functions inherited from <a class="el" href="classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b.html">aestate.opera.DBPool.pooled_db.PooledDB</a></td></tr>
<tr class="memitem:ad89acbbd5b777a724403a3b7031f51db inherit pub_methods_classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b"><td class="memItemLeft" align="right" valign="top">def&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b.html#ad89acbbd5b777a724403a3b7031f51db">__init__</a> (self, creator, mincached=0, maxcached=0, maxshared=0, maxconnections=0, blocking=False, maxusage=None, setsession=None, reset=True, failures=None, ping=1, *args, **kwargs)</td></tr>
<tr class="separator:ad89acbbd5b777a724403a3b7031f51db inherit pub_methods_classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a06ee055becc8b958e365378d4803f3f4 inherit pub_methods_classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b"><td class="memItemLeft" align="right" valign="top">def&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b.html#a06ee055becc8b958e365378d4803f3f4">steady_connection</a> (self)</td></tr>
<tr class="separator:a06ee055becc8b958e365378d4803f3f4 inherit pub_methods_classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a959ae7955f2dfae66ad44fd96e7b0717 inherit pub_methods_classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b"><td class="memItemLeft" align="right" valign="top">def&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b.html#a959ae7955f2dfae66ad44fd96e7b0717">connection</a> (self, shareable=True)</td></tr>
<tr class="separator:a959ae7955f2dfae66ad44fd96e7b0717 inherit pub_methods_classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ad8c85047cc77946bad58a4b0d3f7c5cc inherit pub_methods_classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b"><td class="memItemLeft" align="right" valign="top">def&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b.html#ad8c85047cc77946bad58a4b0d3f7c5cc">dedicated_connection</a> (self)</td></tr>
<tr class="separator:ad8c85047cc77946bad58a4b0d3f7c5cc inherit pub_methods_classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a1af8b808abcac5469d52a0ef2ae33a25 inherit pub_methods_classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b"><td class="memItemLeft" align="right" valign="top">def&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b.html#a1af8b808abcac5469d52a0ef2ae33a25">unshare</a> (self, con)</td></tr>
<tr class="separator:a1af8b808abcac5469d52a0ef2ae33a25 inherit pub_methods_classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a7cf476e69eea8cc1a730098f96503dbd inherit pub_methods_classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b"><td class="memItemLeft" align="right" valign="top">def&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b.html#a7cf476e69eea8cc1a730098f96503dbd">cache</a> (self, con)</td></tr>
<tr class="separator:a7cf476e69eea8cc1a730098f96503dbd inherit pub_methods_classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a80dfa04438c2060ee8867c135f401538 inherit pub_methods_classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b"><td class="memItemLeft" align="right" valign="top">def&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b.html#a80dfa04438c2060ee8867c135f401538">close</a> (self)</td></tr>
<tr class="separator:a80dfa04438c2060ee8867c135f401538 inherit pub_methods_classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a3b1324d0741db4447e876ab702dcbffd inherit pub_methods_classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b"><td class="memItemLeft" align="right" valign="top">def&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b.html#a3b1324d0741db4447e876ab702dcbffd">__del__</a> (self)</td></tr>
<tr class="separator:a3b1324d0741db4447e876ab702dcbffd inherit pub_methods_classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b"><td class="memSeparator" colspan="2">&#160;</td></tr>
</table><table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pub-attribs"></a>
Public Attributes</h2></td></tr>
<tr class="memitem:a9d475e1771249589ffb629d09216e6c2"><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera.html#a9d475e1771249589ffb629d09216e6c2">POOL</a></td></tr>
<tr class="separator:a9d475e1771249589ffb629d09216e6c2"><td class="memSeparator" colspan="2">&#160;</td></tr>
</table><table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="inherited"></a>
Additional Inherited Members</h2></td></tr>
<tr class="inherit_header pub_static_attribs_classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b"><td colspan="2" onclick="javascript:toggleInherit('pub_static_attribs_classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b')"><img src="closed.png" alt="-"/>&#160;Static Public Attributes inherited from <a class="el" href="classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b.html">aestate.opera.DBPool.pooled_db.PooledDB</a></td></tr>
<tr class="memitem:a769527da0064a412426691048b43cc97 inherit pub_static_attribs_classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b"><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b.html#a769527da0064a412426691048b43cc97">version</a> = __version__</td></tr>
<tr class="separator:a769527da0064a412426691048b43cc97 inherit pub_static_attribs_classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b"><td class="memSeparator" colspan="2">&#160;</td></tr>
</table>
<a name="details" id="details"></a><h2 class="groupheader">Detailed Description</h2>
<div class="textblock">
<p class="definition">Definition at line <a class="el" href="_execute_sql_8py_source.html#l00050">50</a> of file <a class="el" href="_execute_sql_8py_source.html">ExecuteSql.py</a>.</p>
</div><h2 class="groupheader">Constructor &amp; Destructor Documentation</h2>
<a id="aba9a630a95683f961029692b32a22a97"></a>
<h2 class="memtitle"><span class="permalink"><a href="#aba9a630a95683f961029692b32a22a97">&#9670;&nbsp;</a></span>__init__()</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">def aestate.work.sql.ExecuteSql.Db_opera.__init__ </td>
          <td>(</td>
          <td class="paramtype">&#160;</td>
          <td class="paramname"><em>self</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">*&#160;</td>
          <td class="paramname"><em>args</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">**&#160;</td>
          <td class="paramname"><em>kwargs</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p class="definition">Definition at line <a class="el" href="_execute_sql_8py_source.html#l00051">51</a> of file <a class="el" href="_execute_sql_8py_source.html">ExecuteSql.py</a>.</p>

</div>
</div>
<h2 class="groupheader">Member Function Documentation</h2>
<a id="a1366af70de61ad202ddd95d0c020ce05"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a1366af70de61ad202ddd95d0c020ce05">&#9670;&nbsp;</a></span>delete()</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">def aestate.work.sql.ExecuteSql.Db_opera.delete </td>
          <td>(</td>
          <td class="paramtype">&#160;</td>
          <td class="paramname"><em>self</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">**&#160;</td>
          <td class="paramname"><em>kwargs</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">
<pre class="fragment">执行删除语句
:param kwargs:包含所有参数:
    last_id:是否需要返回最后一行数据,默认False
    sql:处理过并加上%s的sql语句
    params:需要填充的字段
</pre> 
<p class="definition">Definition at line <a class="el" href="_execute_sql_8py_source.html#l00148">148</a> of file <a class="el" href="_execute_sql_8py_source.html">ExecuteSql.py</a>.</p>
<div class="dynheader">
Here is the call graph for this function:</div>
<div class="dyncontent">
<div class="center"><img src="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera_a1366af70de61ad202ddd95d0c020ce05_cgraph.png" border="0" usemap="#classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera_a1366af70de61ad202ddd95d0c020ce05_cgraph" alt=""/></div>
<map name="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera_a1366af70de61ad202ddd95d0c020ce05_cgraph" id="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera_a1366af70de61ad202ddd95d0c020ce05_cgraph">
<area shape="rect" title=" " alt="" coords="5,137,191,179"/>
<area shape="rect" href="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera.html#a9287232ddbcabdb67c39f934aecc5774" title=" " alt="" coords="239,137,424,179"/>
<area shape="rect" href="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera.html#af621539312f85b1fb61330704f011053" title=" " alt="" coords="472,104,657,145"/>
<area shape="rect" href="namespaceaestate_1_1work_1_1sql_1_1_execute_sql.html#a6a0a15248fd9b6c4471aa1c7832d71b3" title=" " alt="" coords="472,169,657,211"/>
<area shape="rect" href="classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b.html#a959ae7955f2dfae66ad44fd96e7b0717" title=" " alt="" coords="705,104,916,145"/>
<area shape="rect" href="classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b.html#a3acc9fd292d23e1492808430de58bbab" title=" " alt="" coords="988,5,1199,47"/>
<area shape="rect" href="classaestate_1_1opera_1_1_d_b_pool_1_1persistent__pg_1_1_persistent_pg.html#a9f2e1797fbed313968d849400c33c162" title=" " alt="" coords="965,71,1221,112"/>
<area shape="rect" href="classaestate_1_1opera_1_1_d_b_pool_1_1persistent__db_1_1_persistent_d_b.html#a873a9fdf637840f8f5ef989109d6bd11" title=" " alt="" coords="964,136,1223,177"/>
<area shape="rect" href="classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b.html#a06ee055becc8b958e365378d4803f3f4" title=" " alt="" coords="974,201,1213,243"/>
<area shape="rect" href="namespaceaestate_1_1opera_1_1_d_b_pool_1_1steady__db.html#ac744dc4ab3e2dabdd34d3441e7d9ab5c" title=" " alt="" coords="1271,169,1481,211"/>
</map>
</div>

</div>
</div>
<a id="af621539312f85b1fb61330704f011053"></a>
<h2 class="memtitle"><span class="permalink"><a href="#af621539312f85b1fb61330704f011053">&#9670;&nbsp;</a></span>get_conn()</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">def aestate.work.sql.ExecuteSql.Db_opera.get_conn </td>
          <td>(</td>
          <td class="paramtype">&#160;</td>
          <td class="paramname"><em>self</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">
<pre class="fragment">获取数据库连接池
:return:
</pre> 
<p class="definition">Definition at line <a class="el" href="_execute_sql_8py_source.html#l00059">59</a> of file <a class="el" href="_execute_sql_8py_source.html">ExecuteSql.py</a>.</p>
<div class="dynheader">
Here is the call graph for this function:</div>
<div class="dyncontent">
<div class="center"><img src="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera_af621539312f85b1fb61330704f011053_cgraph.png" border="0" usemap="#classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera_af621539312f85b1fb61330704f011053_cgraph" alt=""/></div>
<map name="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera_af621539312f85b1fb61330704f011053_cgraph" id="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera_af621539312f85b1fb61330704f011053_cgraph">
<area shape="rect" title=" " alt="" coords="5,104,191,145"/>
<area shape="rect" href="classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b.html#a959ae7955f2dfae66ad44fd96e7b0717" title=" " alt="" coords="239,104,449,145"/>
<area shape="rect" href="classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b.html#a3acc9fd292d23e1492808430de58bbab" title=" " alt="" coords="521,5,732,47"/>
<area shape="rect" href="classaestate_1_1opera_1_1_d_b_pool_1_1persistent__pg_1_1_persistent_pg.html#a9f2e1797fbed313968d849400c33c162" title=" " alt="" coords="499,71,755,112"/>
<area shape="rect" href="classaestate_1_1opera_1_1_d_b_pool_1_1persistent__db_1_1_persistent_d_b.html#a873a9fdf637840f8f5ef989109d6bd11" title=" " alt="" coords="497,136,756,177"/>
<area shape="rect" href="classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b.html#a06ee055becc8b958e365378d4803f3f4" title=" " alt="" coords="507,201,746,243"/>
<area shape="rect" href="namespaceaestate_1_1opera_1_1_d_b_pool_1_1steady__db.html#ac744dc4ab3e2dabdd34d3441e7d9ab5c" title=" " alt="" coords="804,169,1015,211"/>
</map>
</div>
<div class="dynheader">
Here is the caller graph for this function:</div>
<div class="dyncontent">
<div class="center"><img src="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera_af621539312f85b1fb61330704f011053_icgraph.png" border="0" usemap="#classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera_af621539312f85b1fb61330704f011053_icgraph" alt=""/></div>
<map name="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera_af621539312f85b1fb61330704f011053_icgraph" id="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera_af621539312f85b1fb61330704f011053_icgraph">
<area shape="rect" title=" " alt="" coords="472,71,657,112"/>
<area shape="rect" href="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera.html#a9287232ddbcabdb67c39f934aecc5774" title=" " alt="" coords="239,37,424,79"/>
<area shape="rect" href="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera.html#afc77558cf0747f2325b05305c6ca01ad" title=" " alt="" coords="239,103,424,144"/>
<area shape="rect" href="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera.html#a1366af70de61ad202ddd95d0c020ce05" title=" " alt="" coords="5,5,191,47"/>
<area shape="rect" href="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera.html#af488911adbdabd74a5f54c6c6b4f17d9" title=" " alt="" coords="5,71,191,112"/>
</map>
</div>

</div>
</div>
<a id="a9287232ddbcabdb67c39f934aecc5774"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a9287232ddbcabdb67c39f934aecc5774">&#9670;&nbsp;</a></span>insert()</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">def aestate.work.sql.ExecuteSql.Db_opera.insert </td>
          <td>(</td>
          <td class="paramtype">&#160;</td>
          <td class="paramname"><em>self</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">&#160;</td>
          <td class="paramname"><em>many</em> = <code>False</code>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">**&#160;</td>
          <td class="paramname"><em>kwargs</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">
<pre class="fragment">执行插入语句
:param kwargs:包含所有参数:
    last_id:是否需要返回最后一行数据,默认False
    sql:处理过并加上%s的sql语句
    params:需要填充的字段
:param many:是否为多行执行
</pre> 
<p class="definition">Definition at line <a class="el" href="_execute_sql_8py_source.html#l00108">108</a> of file <a class="el" href="_execute_sql_8py_source.html">ExecuteSql.py</a>.</p>
<div class="dynheader">
Here is the call graph for this function:</div>
<div class="dyncontent">
<div class="center"><img src="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera_a9287232ddbcabdb67c39f934aecc5774_cgraph.png" border="0" usemap="#classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera_a9287232ddbcabdb67c39f934aecc5774_cgraph" alt=""/></div>
<map name="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera_a9287232ddbcabdb67c39f934aecc5774_cgraph" id="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera_a9287232ddbcabdb67c39f934aecc5774_cgraph">
<area shape="rect" title=" " alt="" coords="5,137,191,179"/>
<area shape="rect" href="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera.html#af621539312f85b1fb61330704f011053" title=" " alt="" coords="239,104,424,145"/>
<area shape="rect" href="namespaceaestate_1_1work_1_1sql_1_1_execute_sql.html#a6a0a15248fd9b6c4471aa1c7832d71b3" title=" " alt="" coords="239,169,424,211"/>
<area shape="rect" href="classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b.html#a959ae7955f2dfae66ad44fd96e7b0717" title=" " alt="" coords="472,104,683,145"/>
<area shape="rect" href="classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b.html#a3acc9fd292d23e1492808430de58bbab" title=" " alt="" coords="755,5,965,47"/>
<area shape="rect" href="classaestate_1_1opera_1_1_d_b_pool_1_1persistent__pg_1_1_persistent_pg.html#a9f2e1797fbed313968d849400c33c162" title=" " alt="" coords="732,71,988,112"/>
<area shape="rect" href="classaestate_1_1opera_1_1_d_b_pool_1_1persistent__db_1_1_persistent_d_b.html#a873a9fdf637840f8f5ef989109d6bd11" title=" " alt="" coords="731,136,989,177"/>
<area shape="rect" href="classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b.html#a06ee055becc8b958e365378d4803f3f4" title=" " alt="" coords="741,201,979,243"/>
<area shape="rect" href="namespaceaestate_1_1opera_1_1_d_b_pool_1_1steady__db.html#ac744dc4ab3e2dabdd34d3441e7d9ab5c" title=" " alt="" coords="1037,169,1248,211"/>
</map>
</div>
<div class="dynheader">
Here is the caller graph for this function:</div>
<div class="dyncontent">
<div class="center"><img src="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera_a9287232ddbcabdb67c39f934aecc5774_icgraph.png" border="0" usemap="#classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera_a9287232ddbcabdb67c39f934aecc5774_icgraph" alt=""/></div>
<map name="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera_a9287232ddbcabdb67c39f934aecc5774_icgraph" id="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera_a9287232ddbcabdb67c39f934aecc5774_icgraph">
<area shape="rect" title=" " alt="" coords="239,39,424,80"/>
<area shape="rect" href="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera.html#a1366af70de61ad202ddd95d0c020ce05" title=" " alt="" coords="5,5,191,47"/>
<area shape="rect" href="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera.html#af488911adbdabd74a5f54c6c6b4f17d9" title=" " alt="" coords="5,71,191,112"/>
</map>
</div>

</div>
</div>
<a id="afc77558cf0747f2325b05305c6ca01ad"></a>
<h2 class="memtitle"><span class="permalink"><a href="#afc77558cf0747f2325b05305c6ca01ad">&#9670;&nbsp;</a></span>select()</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">def aestate.work.sql.ExecuteSql.Db_opera.select </td>
          <td>(</td>
          <td class="paramtype">&#160;</td>
          <td class="paramname"><em>self</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">**&#160;</td>
          <td class="paramname"><em>kwargs</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">
<pre class="fragment">查找多个
:param kwargs:包含所有参数:
    last_id:是否需要返回最后一行数据,默认False
    sql:处理过并加上%s的sql语句
    params:需要填充的字段
    print_sql:是否打印sql语句
:return:
</pre> 
<p class="definition">Definition at line <a class="el" href="_execute_sql_8py_source.html#l00067">67</a> of file <a class="el" href="_execute_sql_8py_source.html">ExecuteSql.py</a>.</p>
<div class="dynheader">
Here is the call graph for this function:</div>
<div class="dyncontent">
<div class="center"><img src="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera_afc77558cf0747f2325b05305c6ca01ad_cgraph.png" border="0" usemap="#classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera_afc77558cf0747f2325b05305c6ca01ad_cgraph" alt=""/></div>
<map name="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera_afc77558cf0747f2325b05305c6ca01ad_cgraph" id="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera_afc77558cf0747f2325b05305c6ca01ad_cgraph">
<area shape="rect" title=" " alt="" coords="5,137,191,179"/>
<area shape="rect" href="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera.html#af621539312f85b1fb61330704f011053" title=" " alt="" coords="239,104,424,145"/>
<area shape="rect" href="namespaceaestate_1_1work_1_1sql_1_1_execute_sql.html#a6a0a15248fd9b6c4471aa1c7832d71b3" title=" " alt="" coords="239,169,424,211"/>
<area shape="rect" href="classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b.html#a959ae7955f2dfae66ad44fd96e7b0717" title=" " alt="" coords="472,104,683,145"/>
<area shape="rect" href="classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b.html#a3acc9fd292d23e1492808430de58bbab" title=" " alt="" coords="755,5,965,47"/>
<area shape="rect" href="classaestate_1_1opera_1_1_d_b_pool_1_1persistent__pg_1_1_persistent_pg.html#a9f2e1797fbed313968d849400c33c162" title=" " alt="" coords="732,71,988,112"/>
<area shape="rect" href="classaestate_1_1opera_1_1_d_b_pool_1_1persistent__db_1_1_persistent_d_b.html#a873a9fdf637840f8f5ef989109d6bd11" title=" " alt="" coords="731,136,989,177"/>
<area shape="rect" href="classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b.html#a06ee055becc8b958e365378d4803f3f4" title=" " alt="" coords="741,201,979,243"/>
<area shape="rect" href="namespaceaestate_1_1opera_1_1_d_b_pool_1_1steady__db.html#ac744dc4ab3e2dabdd34d3441e7d9ab5c" title=" " alt="" coords="1037,169,1248,211"/>
</map>
</div>

</div>
</div>
<a id="af488911adbdabd74a5f54c6c6b4f17d9"></a>
<h2 class="memtitle"><span class="permalink"><a href="#af488911adbdabd74a5f54c6c6b4f17d9">&#9670;&nbsp;</a></span>update()</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">def aestate.work.sql.ExecuteSql.Db_opera.update </td>
          <td>(</td>
          <td class="paramtype">&#160;</td>
          <td class="paramname"><em>self</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">**&#160;</td>
          <td class="paramname"><em>kwargs</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td></td>
        </tr>
      </table>
</div><div class="memdoc">
<pre class="fragment">执行更新语句
:param kwargs:包含所有参数:
    last_id:是否需要返回最后一行数据,默认False
    sql:处理过并加上%s的sql语句
    params:需要填充的字段
</pre> 
<p class="definition">Definition at line <a class="el" href="_execute_sql_8py_source.html#l00138">138</a> of file <a class="el" href="_execute_sql_8py_source.html">ExecuteSql.py</a>.</p>
<div class="dynheader">
Here is the call graph for this function:</div>
<div class="dyncontent">
<div class="center"><img src="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera_af488911adbdabd74a5f54c6c6b4f17d9_cgraph.png" border="0" usemap="#classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera_af488911adbdabd74a5f54c6c6b4f17d9_cgraph" alt=""/></div>
<map name="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera_af488911adbdabd74a5f54c6c6b4f17d9_cgraph" id="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera_af488911adbdabd74a5f54c6c6b4f17d9_cgraph">
<area shape="rect" title=" " alt="" coords="5,137,191,179"/>
<area shape="rect" href="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera.html#a9287232ddbcabdb67c39f934aecc5774" title=" " alt="" coords="239,137,424,179"/>
<area shape="rect" href="classaestate_1_1work_1_1sql_1_1_execute_sql_1_1_db__opera.html#af621539312f85b1fb61330704f011053" title=" " alt="" coords="472,104,657,145"/>
<area shape="rect" href="namespaceaestate_1_1work_1_1sql_1_1_execute_sql.html#a6a0a15248fd9b6c4471aa1c7832d71b3" title=" " alt="" coords="472,169,657,211"/>
<area shape="rect" href="classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b.html#a959ae7955f2dfae66ad44fd96e7b0717" title=" " alt="" coords="705,104,916,145"/>
<area shape="rect" href="classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b.html#a3acc9fd292d23e1492808430de58bbab" title=" " alt="" coords="988,5,1199,47"/>
<area shape="rect" href="classaestate_1_1opera_1_1_d_b_pool_1_1persistent__pg_1_1_persistent_pg.html#a9f2e1797fbed313968d849400c33c162" title=" " alt="" coords="965,71,1221,112"/>
<area shape="rect" href="classaestate_1_1opera_1_1_d_b_pool_1_1persistent__db_1_1_persistent_d_b.html#a873a9fdf637840f8f5ef989109d6bd11" title=" " alt="" coords="964,136,1223,177"/>
<area shape="rect" href="classaestate_1_1opera_1_1_d_b_pool_1_1pooled__db_1_1_pooled_d_b.html#a06ee055becc8b958e365378d4803f3f4" title=" " alt="" coords="974,201,1213,243"/>
<area shape="rect" href="namespaceaestate_1_1opera_1_1_d_b_pool_1_1steady__db.html#ac744dc4ab3e2dabdd34d3441e7d9ab5c" title=" " alt="" coords="1271,169,1481,211"/>
</map>
</div>

</div>
</div>
<h2 class="groupheader">Member Data Documentation</h2>
<a id="a9d475e1771249589ffb629d09216e6c2"></a>
<h2 class="memtitle"><span class="permalink"><a href="#a9d475e1771249589ffb629d09216e6c2">&#9670;&nbsp;</a></span>POOL</h2>

<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">aestate.work.sql.ExecuteSql.Db_opera.POOL</td>
        </tr>
      </table>
</div><div class="memdoc">

<p class="definition">Definition at line <a class="el" href="_execute_sql_8py_source.html#l00053">53</a> of file <a class="el" href="_execute_sql_8py_source.html">ExecuteSql.py</a>.</p>

</div>
</div>
<hr/>The documentation for this class was generated from the following file:<ul>
<li>aestate/work/sql/<a class="el" href="_execute_sql_8py_source.html">ExecuteSql.py</a></li>
</ul>
</div><!-- contents -->
<!-- start footer part -->
<hr class="footer"/><address class="footer"><small>
Generated by &#160;<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/>
</a> 1.8.17
</small></address>
</body>
</html>
